<?php
session_start();
include("global.php");
?>
<html>
<head>
<title>::.::.:: APPMA ||  Southern  Executive Committee 2009-2010  ::.::.::</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- ImageReady Styles (index.psd) -->

<link href="css/styleinner.css" rel="stylesheet" type="text/css">

<link href="css/css_tab/samples.css" rel="stylesheet" type="text/css">
<link href="css/css_tab/SprySlidingPanels.css" rel="stylesheet" type="text/css">
<link href="css/css_tab/tab_style.css" rel="stylesheet" type="text/css">
<!-- End ImageReady Styles -->
<script src="java/SprySlidingPanels.js" type="text/javascript"></script>
<style type="text/css">
<!--

#usefullinks {
	position:absolute;
	width:381px;
	height:94px;
	z-index:1;
	left: 38px;
	top: 30px;
}
.style1 {font-size: 12px}
-->
</style>
</head>
<body style="margin-top: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px;">
<!-- ImageReady Slices (index.psd) -->
<center>
  <div id="Table_01">
	<div id="index-01">
	
	  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="621" height="150">
        <param name="movie" value="flash/title.swf">
        <param name="quality" value="high">
        <embed src="flash/title.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="621" height="150"></embed>
      </object>
    </div>
	<div id="index-02">
		
	
			  <div id="contactlink" onClick="MM_goToURL('parent','contact.php');return document.MM_returnValue"></div>
	  <div id="feedback" onClick="MM_goToURL('parent','feedback.php');return document.MM_returnValue"></div>
	  <div id="sitemap" onClick="MM_goToURL('parent','sitemap.php');return document.MM_returnValue"></div>

<?php if(isset($_SESSION['SESS_MEMBER_ID'])) {
	echo '<div id="logout"><a href="logout.php">Logout</a></div>';
}	  
?> 
	
	

	  <div id="search">
	  <form action="search.php" method="post">
	  <td valign="middle" height="30px">
	  <input type="text" name="search" height="20px" size="35"></td>
	  <td valign="middle" height="30px">
	  <input type="submit" class="searchbtn" value=""></td>
	  </form>
	  </div>
	
	
	
	</div>
	<div id="index-03">
		
		
				<?php
				$File = "nav.html";
				$fh = fopen($File, 'r');
				$List = fread($fh, filesize($File));
				fclose($fh);
				echo $List;
				?> 
		
		
	</div>
	<div id="index-04">
    <?php
    $File = "menuleft.html";
    $fh = fopen($File, 'r');
    $List = fread($fh, filesize($File));
    fclose($fh);
    echo $List;
    ?> 
		
    
    
   
    </div>
	<div id="index-09">
	  <div id="platinum">

<?php
$con = mysql_connect("localhost","appma" ,"database");
mysql_select_db("162_appma", $con);
$sql="SELECT link FROM sponsor WHERE sponsor='platinum'";
if (!$sql)
{
	die('Could Not Complete Please Try Again Later: ' );
}
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
?>
<a href="<?php echo $row['link']; ?>" target="_blank">
<img src="uploader/sponsor/platinum.jpg"></a>

	  </div>
	</div>
	<div id="index-13">
	  <div id="gold">
	  
	<?php
	$con = mysql_connect("localhost","appma" ,"database");
	mysql_select_db("162_appma", $con);
	$sql="SELECT link FROM sponsor WHERE sponsor='gold'";
	if (!$sql)
	{
		die('Could Not Complete Please Try Again Later: ' );
	}
	$result=mysql_query($sql);
	$row = mysql_fetch_array($result);
	?>
<a href="<?php echo $row['link']; ?>" target="_blank">
<img src="uploader/sponsor/gold.jpg"></a>
	  
	  </div>
    
    </div>
	<div id="index-16">
	  <div id="contact">
	     <?php include "Address.php" ?>
      </div>

	</div>
    <div id="mid">
    <div id="text">
      <div> 
	<?php
	$util =new Util();
	$util->Init();
	if($util->getvalue("re")==""){
		$result = $util->Query("select * from tblElection order by Id desc limit 1");
	}
	else
	{
		$result = $util->Query("SELECT * FROM tblElection WHERE Id = ".$util->getvalue("re"));
	}
	while($row = mysql_fetch_array($result))
	{
		echo "<div align=\"left\"><font size=\"+2\">SOUTHERN EXECUTIVE COMMITTEE ".$row["Description"]."</font></div>";
	}
	?>
        
      </div>
      <br>
	<select id="ddlResultType"   >
<?php
$util =new Util();
$util->Init();
$result = $util->Query("SELECT * FROM tblelection");
while($row = mysql_fetch_array($result))
{
	if($row["Id"]==$util->getvalue("re"))
		echo "<option selected=true value=".$row["Id"]." >".$row["Description"]."</option>";
	else
		echo "<option value=".$row["Id"]." >".$row["Description"]."</option>";
}
$util->Close();
?>

</select>
<a href="#" id="lnkGo" onClick="linkCenteralListGo();" >Go</a>
<br /><br /><br /><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="11%"><strong>S.No,</strong></td>
          <td width="49%"><strong>Names Members with address</strong></td>
          <td width="40%">&nbsp;</td>
        </tr>
<?php
$util =new Util();
$util->Init();
if($util->getvalue("re")==""){
	$result = $util->Query("SELECT * FROM tblmembers WHERE LookUpId=1002 and ElectionId = (select id from tblElection order by Id desc limit 1) order by ElectionId desc");
}
else
{
	$result = $util->Query("SELECT * FROM tblmembers WHERE LookUpId=1002 and ElectionId = ".$util->getvalue("re"));
}
$electionId = false;
$count =0;
while($row = mysql_fetch_array($result))
{
	$count++;
	if(!$electionId){
		echo "<script type='text/javascript'> var dropdownId='".$row["ElectionId"]. "'</script>";
		$electionId = true;
	}
	if (isset($_SESSION['type']) && $_SESSION['type']== 'admin'){
		echo "<tr><td valign='top'><strong>".$count.".</strong></td><td valign='top'><span class='style1'>".$row["Name"].", <br>".$row["Designation"].",<br>".$row["EmailId"].".<br>".$row["Phone"]."	</span></td><td><img width='143' height='169' src=".$row["Address"]."><br/><a style='color:red;' href='javascript:ExecutiveRemove(".$row["Id"].")' >Remove</a></td></tr>";
	}
	else{
		echo "<tr><td valign='top'><strong>".$count.".</strong></td><td valign='top' class='CommuntyPage'> <span class='style1'><b>".$row["Name"]."</b> <br>".$row["Designation"].",<br><b>".$row["EmailId"]."</b>".$row["Address"]."	</span></td><td class='CommuntyPage'><img width='143' height='169' src=".$row["ImagePath"]."></td></tr>";
	}
	
}
$util->Close();
?>
</ol>
</table>
      </div>
<script src="java/Scripts/jquery-1.7.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
var pageName = 'Southern.php';
</script>
<script src="java/Scripts/default.js" type="text/javascript"></script>
	<div id="bottom">
		<img src="images/index_18.jpg" width="1003" height="42" alt="">	</div>
</div>
</div>
</center>
<!-- End ImageReady Slices -->
</body>
</html>